﻿CREATE TABLE [org].[Division] (
    [DivisionId]                      INT             NOT NULL,
    [DivisionCode]                    CHAR (5)        NOT NULL,
    [DivisionName]                    VARCHAR (50)    NOT NULL,
    [DivisionDescription]             NVARCHAR (1000) NULL,
    [DivisionFlashPnlMinThresholdGBP] DECIMAL (18, 2) NULL,
    [DivisionFlashPnLMaxThresholdGBP] DECIMAL (18, 2) NULL,
    [DivisionFlashManualUpload]       BIT             NOT NULL,
    [DivisionFlashMurexUpload]        BIT             NOT NULL,
    [DivisionStartDate]               DATE            NOT NULL,
    [DivisionEndDate]                 DATE            NULL,
    [IsLatest]                        BIT             NOT NULL,
    [IsActive]                        BIT             NOT NULL,
    [IsInternal]                      BIT             NOT NULL,
    PRIMARY KEY CLUSTERED ([DivisionId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

